package com.onlinesys.service;

import java.sql.SQLException;
import java.util.List;

import com.onlinesys.beans.ReportBean;

public interface ReportService {

    public List<ReportBean> getPeriodReport(int startRow, int pageSize, int reportYear, int reportMonthStart, int reportMonthEnd, String drawingNum, String vendor) throws Exception;

    public List<ReportBean> getItmesReport(int startRow, int pageSize, String startDate, String endDate) throws SQLException;

    public List<ReportBean> getClassReport(int startRow, int pageSize, String startDate, String endDate) throws SQLException;

    public List<ReportBean> getLostReport(int startRow, int pageSize, String startDate, String endDate) throws SQLException;
    
    public int getPeriodReportTotalCount(int startRow, int pageSize, String startDate, String endDate) throws SQLException;

    public int getItmesReportTotalCount(int startRow, int pageSize, String startDate, String endDate) throws SQLException;

    public int getClassReportTotalCount(int startRow, int pageSize, String startDate, String endDate) throws SQLException;

    public int getLostReportTotalCount(int startRow, int pageSize, String startDate, String endDate) throws SQLException;

	public int getPeriodReportCount(int reportYear, int reportMonthStart, int reportMonthEnd, String drawingNum, String vendor) throws SQLException;

	public List<ReportBean> getItemReport(int startRow, int pageSize, String start_date, String end_date, String drawingNum, String vendor) throws SQLException;

	public int getItemReportCount(String start_date, String end_date, String drawingNum, String vendor) throws SQLException;
	
	public List<ReportBean> getClassItemReport(int startRow, int pageSize, String start_date, String end_date, String drawingNum, String vendor, int classId) throws SQLException;

	public int getClassItemReportCount(String start_date, String end_date, String drawingNum, String vendor, int classId) throws SQLException;

	public List<ReportBean> getRepositoryWarnReport(int i, int pageSize,
			String start_date, String end_date, String drawingNum, String vendor, int repositoryType) throws SQLException;

	public int getRepositoryWarnReportCount(String start_date, String end_date,
			String drawingNum, String vendor, int repositoryType) throws SQLException;

}
